Query not executed

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND (concert.online = 1 OR concert.online = 0) ORDER BY priority ASC' at line 5

Query:SELECT band.id, DATE_FORMAT(concert.date, '%e %M %Y') AS date, DATE_FORMAT(concert.date, '%e %M') AS shortdate, DATE_FORMAT(concert.date, '%e-%M-%Y') AS urldate, DATE_FORMAT(concert.date, '%Y-%m-%dT%TZ') AS isodate, concert.online, concertband.priority, IF(client IS NULL,'',client) AS client FROM concert INNER JOIN concertband ON concertband.concertid = concert.id INNER JOIN band ON concertband.bandid = band.id WHERE concert.id = AND (concert.online = 1 OR concert.online = 0) ORDER BY priority ASCempty queryconcert with id not foundQuery not executed

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 5

Query:SELECT venue.id, venue.id AS venueid, venue.name AS venuename, REPLACE(venue.name, ' ', '-') AS urlvenuename, venue.website AS venuewebsite, venue.town AS venuelocation, venue.street, venue.housenumber, venue.postalcode, venue.town, venue.country, REPLACE(venue.town, ' ', '-') AS urlvenuelocation, DATE_FORMAT(concert.date, '%Y-%m-%dT%TZ') AS newestconcertdate, countries.name AS countryname FROM venue INNER JOIN concert ON concert.venueid = venue.id INNER JOIN countries ON venue.countryid = countries.id WHERE concert.id =empty queryerror (1)Query not executed

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND concert.id != LIMIT 1000' at line 4

Query:SELECT concert.id, concert.id AS concertsvenueid, DATE_FORMAT(concert.date, '%e %M %Y') AS concertsvenuedate, DATE_FORMAT(concert.date, '%e-%M-%Y') AS urlconcertsvenuedate, DATE_FORMAT(concert.date, '%Y-%m-%dT%TZ') AS newestconcertdate FROM concert WHERE concert.venueid = AND concert.id != LIMIT 1000empty queryQuery not executed

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY photo.filename' at line 7

Query:SELECT photo.*, band.name AS bandname, venue.name AS venuename, REPLACE(venue.name, ' ', '-') AS urlvenuename, REPLACE(band.name, ' ', '-') AS urlbandname FROM photo INNER JOIN band ON band.id = photo.bandid INNER JOIN concert ON concert.id = photo.concertid INNER JOIN venue ON venue.id = concert.venueid WHERE photo.concertid = ORDER BY photo.filenameempty queryno pics found (01 January 1970) | Basementonline Concertpics
X
Bands Venues
No bands found {{band.name}} ({{band.noofconcerts}})
No venues found {{venue.name}} ({{venue.noofconcerts}})
{{venue.town}}

{VENUE} {/VENUE} {BANDS} {/BANDS} {VENUE} {/VENUE} {BANDS} {/BANDS}

0 bands in ,

1 January 1970
pictures

Info & links

{FILES}
click to enlarge
{/FILES}